<?php

class EquipmentController extends Controller
{
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout='//layouts/customer';
        public $customer;
        public $location;
	/**
	 * @return array action filters
	 */
	public function filters()
	{
		return array(
			'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules()
	{
		return array(
			array('allow',  // allow all users to perform 'index' and 'view' actions
				
				'users'=>array('@'),
			),
			
			array('deny',  // deny all users
				'users'=>array('*'),
			),
		);
	}

	

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id)
	{
		$model=$this->loadModel($id);
                $custno=$model->custno;
                $locno=$model->locno;
                $this->loadObject($custno, $locno);
		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		

		$this->render('update',array(
			'model'=>$model,
                        'location'=>$this->location,
                        'customer'=>$this->customer,
		));
	}

	
	/**
	 * Lists all models.
	 */
	public function actionIndex($locno)
	{              $custno = Yii::app()->user->custno;
		$this->loadObject($custno, $locno);
                
                $this->render('index',array(
                    'location'=>$this->location,
                    'customer'=>$this->customer,
                ));
	}


        public function loadObject($custno,$locno){
            $this->location=Locations::model()->find('custno=:custno AND locno=:locno',array(
                'custno'=>$custno,
                'locno'=>$locno,
            ));
            
            $this->customer=Customers::model()->find('custno=:custno',array(
                'custno'=>$custno,
            ));
            
            if($this->location==NULL || $this->customer==NULL){
                throw new CHttpException('404','Your request could not process, that is we all know');
            }
        }
	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id)
	{
		$model=Equipment::model()->findByPk($id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model)
	{
		if(isset($_POST['ajax']) && $_POST['ajax']==='equipment-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}
        
        public function actionEquipmentList($custno,$locno,$page=1,$sort=NULL,$dir=NULL){
            //we decrease $page by 1 because in Extjs first page is 1, but in our sql first page is 0;
            if($page>0)$page--;
            
            $crit=new CDbCriteria();
            $crit->condition='custno=:custno AND locno=:locno';
            $crit->params=array(
                'custno'=>$custno,
                'locno'=>$locno,
            );
            
            $order=CJSON::decode($sort);
            if($sort!=NULL){
                $crit->order=$order[0]['property'].' '.$order[0]['direction'];
            }
            
            $data=new CActiveDataProvider('Equipment',array(
                'criteria'=>$crit,
                'pagination'=>array(
                    'pageSize'=>20,
                    'currentPage'=>$page,
                )
            ));
            
            if($data!=NULL && count($data->getData())>0){
                $rs=array();
                $rs['totalCount']=$data->getTotalItemCount();
                foreach($data->getData() as $i=>$item){
                    $rs['data'][$i]=$item->getAttributes();
                    $rs['data'][$i]['pmrequiredText']=$item->pmrequiredText;
                    $rs['data'][$i]['statusText']=$item->statusText;
                    $rs['data'][$i]['planTypeText']=$item->PlanTypeText;
                }
                echo json_encode($rs);
            }
            Yii::app()->end();
        }
}
